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