UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pttgn2swjvuXgAV7ZtBB886cp2Fuz1f0DOAoDvRSeng=' 
WHERE 
  key_id = 'b627a64f67ea721e6b76de263ee70156e0eda68c4dd460388d53540022bd9b1c' 
  AND (
    token = 'pttgn2swjvuXgAV7ZtBB886cp2Fuz1f0DOAoDvRSeng=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026