UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZJyrDo2ViH7bjC3dEsOMVnGjHLrPDG/Hy22ZnaH1n38=' 
WHERE 
  key_id = 'cc1b629a5b50e19d7863c4b3d20c4490910691b1124ba92dfb17b3843667386b' 
  AND (
    token = 'ZJyrDo2ViH7bjC3dEsOMVnGjHLrPDG/Hy22ZnaH1n38=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025