UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6SDPFzIRKt8UlzMGCL97ZEBJcWfSL9aeiJ3mpaUSyxo='
WHERE
key_id = '3149a6b1b873bacc1fdd321335f2f3b10bbcf1e8b69ac85faf5a7de807793f89'
AND (
token = '6SDPFzIRKt8UlzMGCL97ZEBJcWfSL9aeiJ3mpaUSyxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)