UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vp9tMmOgF+XASL2OiVpeH1xzqYvuAqK+H50pu0mmpCY='
WHERE
key_id = '6ad5c57696d50aebeb09dae40733f1527f21922c51786239b91e3adcd2e6f2f9'
AND (
token = 'vp9tMmOgF+XASL2OiVpeH1xzqYvuAqK+H50pu0mmpCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)