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