UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gKpSWizB3j57oxaKs/c77hZmD7NyXKFTHPI3AqeIlF8='
WHERE
key_id = 'b6d168ba9237382d61a1b565436f0035e3f18b6f642216f1db64f4c89a0fda4d'
AND (
token = 'gKpSWizB3j57oxaKs/c77hZmD7NyXKFTHPI3AqeIlF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)