UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0Pb3t3CYA8gC7ac+fOfeUApE6w4gSecd/9eX9f1AAS0=' 
WHERE 
  key_id = '3214335118b248700e768f8ea5cbc84597b51a470b33ea5b5d13efd73ac60dde' 
  AND (
    token = '0Pb3t3CYA8gC7ac+fOfeUApE6w4gSecd/9eX9f1AAS0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023