UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LayqGOePj4jweZ2zDGx2i0DDLCgTML9lQPbC3cZmeRk='
WHERE
key_id = 'd9697c6afa4ef12da6e6c4b1bef372a24f4184608fa8cfade09448db0ebe6be8'
AND (
token = 'LayqGOePj4jweZ2zDGx2i0DDLCgTML9lQPbC3cZmeRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)