UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xMOX9HT7fWXvPYfRnEG0uji5VNk6Xb1z8G2Sf/bj1lg=' 
WHERE 
  key_id = '9f73c0366ad6c5591df4d5ea186a9cf136ac1544c17fe2d956e2b53de0c278a7' 
  AND (
    token = 'xMOX9HT7fWXvPYfRnEG0uji5VNk6Xb1z8G2Sf/bj1lg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027