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