UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fMisroF2Y7jwreUAFgkkUhCWrnb6EDOYM7qeZ487aCU='
WHERE
key_id = '79b5ae580060c0334aef50a3e780487298eb8584bf754aaa51a47aad32e46b7a'
AND (
token = 'fMisroF2Y7jwreUAFgkkUhCWrnb6EDOYM7qeZ487aCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)