UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wmY0pynuz4zHi9vzYnVqmhsJH7kVx86Ejl6ywOXWTXs='
WHERE
key_id = '42ab744ec4317c62893b221c116ee207f573c1573f520f1022bd4e2a4ca6de4b'
AND (
token = 'wmY0pynuz4zHi9vzYnVqmhsJH7kVx86Ejl6ywOXWTXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)