UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tWVhJ61HVQx/9Oevu7rArsb36vL7/81Il8V7YILfur4=' 
WHERE 
  key_id = '09bb5aaeee95993642ccc8454f5a99cec263e86551ff18b73a2dd0df3bfb2bee' 
  AND (
    token = 'tWVhJ61HVQx/9Oevu7rArsb36vL7/81Il8V7YILfur4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033