UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bFrRRuMQp85alFU/HTBADBJKfNoHKoCgjNYUzoyZGDg='
WHERE
key_id = 'c4778438d994d127943d28088aa5b42180242c1b323bf85ba0642857b1af5e14'
AND (
token = 'bFrRRuMQp85alFU/HTBADBJKfNoHKoCgjNYUzoyZGDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)