UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'naTHJU79oJ+2ongRwyCntpGdLn47138B5NeJ8fmzcCY=' 
WHERE 
  key_id = 'b3dc55ae5b353f9447026aca20a8c475dd502d93c1b5d4c3af9b72c17e6a9d88' 
  AND (
    token = 'naTHJU79oJ+2ongRwyCntpGdLn47138B5NeJ8fmzcCY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027