UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'spwVH9YlLPtI6iGOlwjxiTFZSm742Leq3rKw77Stjiw='
WHERE
key_id = '9c18be84602ebcd75728db19470acf363eb3aa33e0d54fcfed46da87ce23535d'
AND (
token = 'spwVH9YlLPtI6iGOlwjxiTFZSm742Leq3rKw77Stjiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)