UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GXRKOhbBvwuwnKV1v7lsJqJFLgSEvuTgEg/EjKty4jg='
WHERE
key_id = '4b37e42388633412d79c8aa9bb005ac4ae7859e8a7e920c377b88eaaeb7ae56d'
AND (
token = 'GXRKOhbBvwuwnKV1v7lsJqJFLgSEvuTgEg/EjKty4jg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)