UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qo4sflDWdUVz9c4cCR5YCh+UaRZX23GQrWu7Jxw+k5A=' 
WHERE 
  key_id = 'e6cd388fc7c559bc5677ad8d10cebd1a48602b7036ec0df4b74bc5ffb2cb5acf' 
  AND (
    token = 'qo4sflDWdUVz9c4cCR5YCh+UaRZX23GQrWu7Jxw+k5A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040