UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xes8hy1SxBGr/JkKAtp30PbvgzwhPRs7M6STbCC4/xA='
WHERE
key_id = 'c80382e99fef3edc6ee1a8895ab9c4557dd61341063913c19695168253ff0c6f'
AND (
token = 'xes8hy1SxBGr/JkKAtp30PbvgzwhPRs7M6STbCC4/xA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)