UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'P1CEP76+S9PnQK3AfkESvpP9v0G+DeTyFshb33EWbsk=' 
WHERE 
  key_id = '38266af74f606578e1f35bc80815fe3e7a1a82eba283cc2d417134f588473937' 
  AND (
    token = 'P1CEP76+S9PnQK3AfkESvpP9v0G+DeTyFshb33EWbsk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033