UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8AQppzTui9lUdgZU8Wmd35FH0A36PlP0t62yAHDvWOA='
WHERE
key_id = 'a86ad40b3f06027fa1059b0fd8e030e18579f69456bf49152e9be223bb4a2e37'
AND (
token = '8AQppzTui9lUdgZU8Wmd35FH0A36PlP0t62yAHDvWOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)