UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWkdHs/RP5kIZYnWAZuQ5W6Rcsu29Du1ngAHxhWY9w8='
WHERE
key_id = 'a77e4c82e9246aebd90e4ea649fd4f26533b72b035405041a5c40194fcfee0fc'
AND (
token = 'XWkdHs/RP5kIZYnWAZuQ5W6Rcsu29Du1ngAHxhWY9w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)