UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sXYZlTUPu/g+y9Jj5PjaJKRTqJ24EnaS5/bIdEJAQNY=' 
WHERE 
  key_id = '14d29a8e6b53b986b18b77e28f67c3194459c5fb0e999672bc69d819a302cbf7' 
  AND (
    token = 'sXYZlTUPu/g+y9Jj5PjaJKRTqJ24EnaS5/bIdEJAQNY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044