UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pR2DhMjtozSwddhIe57KxFjt/WSliqfyIYSNExarCbA='
WHERE
key_id = '78bd3a6ab364ae3b26e753a4ea6257a3f483401a6e17c526df978abb60808145'
AND (
token = 'pR2DhMjtozSwddhIe57KxFjt/WSliqfyIYSNExarCbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)