UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HjNBpk4zbZA2ZYwppc/gL1cED5TwRdynuTZCgsyShKk=' 
WHERE 
  key_id = 'c4d593dc309df62c86464e23bd8b0b96b5c63539c146d6819a89b8412f6709b2' 
  AND (
    token = 'HjNBpk4zbZA2ZYwppc/gL1cED5TwRdynuTZCgsyShKk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021